How to: Import database object(s) other than tables from another Access database
Solution:
Open the database to which to import objects, select 'Get External Data' from the 'File' menu and select 'Import...', specify the database and the objects to import, and choose 'OK'.
1) If the destination database (the database to which to import objects) is not already open, open the database.
2) (Optional) Activate its Database window:
a) Select the 'Window' menu.
b) Select the name of the database.
3) Select the 'File' menu and select 'Get External Data'. (A submenu appears.)
4) Select 'Import...' from the submenu. (The Import dialog box appears.)
5) Make sure 'Microsoft Access (*.mdb;*.mdw;)' is selected in the 'Files of type' drop-down list box.
6) Select the drive where the source database (the database from which to retrieve objects) is located from the 'Look in' drop-down list.
the Look in drop-down list
7) Select the folder that contains the source database from the 'Look in' list box. (The database file is displayed.)
NOTE: If the database file is in a subfolder, continue selecting folders until the desired database file is displayed.
8) Select the database file. (The file is highlighted.)
9) Click 'Import'. (The Import Objects dialog box appears.)
the Import button
10) If the source database has a database password:
a) Type the password in the 'Password' box.
b) Click 'OK'.
11) Click the tab for the type of object to import.
12) Select each object to import. (Each object is highlighted.)
Selecting an object on an object tab
13) (Optional) To import select queries as tables:
a) Click 'Options'. (The Import Objects dialog box expands to display importing options.)
b) Select the 'As Tables' radio button in the 'Import Queries' group.
the As Tables radio button
14) Repeat steps 11) through 13) for each type of object to import.
15) Click 'OK' to import all of the selected objects.
